Hi,

Scenario:

Table 1 contains:

event_id
event_name
event_type

Table 2 contains:

event_meals
event_drinks
event_accesories

Table 3 contains:

event_tables
event_flowers
event_chairs

How do I go about making sure that these three tables are linked with each other so when I do a search for a specific date's event it will show me all the information out of both tables for that spesific event?

Could someone please explain to me how to link multiple tables with each other?

Thank You

put event id into each of the tables keeping the id the same for each entry that matches.

then you can grab it all easily like

select * from table1 t1 left join table2 t2 on t1.id=t2.id left join table3 t3 on t2.id=t3.id.

or

select * from table1 t1, table2 t2, table3 t3
where t1.id=t2.id
and t2.id=t3.id

Ibbo