Still feel like a newie
Hope somebody has a good solution to this:
Got 3 tables with following fields
Table 1 as t1:
-ID
-first name
-last name
Table 2 as t2:
-ID
-Street
-City
Table 3 as t3:
-ID
-IDTable1
-IDTable2
-Description
The first part of select where should be:
where t3.idTable1=t1.id or tdTable2=t2.ID
means that data from table 3 has to be shown with either table 1 or 2.
Now when I want to select with more conditions using a search script, espl. where City in table 2 is London, or Street is "Oxford street". How do I do it. Dont't forget the "or" in the first part of where!!
Hope I wrote everything necessary, got questions, email me.
Thanks in Advance
Chris
Hope somebody has a good solution to this:
Got 3 tables with following fields
Table 1 as t1:
-ID
-first name
-last name
Table 2 as t2:
-ID
-Street
-City
Table 3 as t3:
-ID
-IDTable1
-IDTable2
-Description
The first part of select where should be:
where t3.idTable1=t1.id or tdTable2=t2.ID
means that data from table 3 has to be shown with either table 1 or 2.
Now when I want to select with more conditions using a search script, espl. where City in table 2 is London, or Street is "Oxford street". How do I do it. Dont't forget the "or" in the first part of where!!
Hope I wrote everything necessary, got questions, email me.
Thanks in Advance
Chris