performing select over 2 tables

buducom

using MYSQL

I have one table A
which includes a whole bunch of data
and it has one field: contactid.

now i do a select on this table A for some fields and do a where clause on it and i want to do a search on table B where the contactid from table A is the primary key in table B.

table B contains columns such as names, address etc...
on which i also want to do a where select.
But i dont know how to link it up. I am sure its union, join or some kind of this statement but i am new to this.

Thank you for your help

danie

bad76

Hi,
usually the SQL statement you are looking for, is like that:

SELECT a.*, b.name, b.address
FROM tableA a, tableB b
WHERE a.ID=b.contactID AND a.data>... AND ...

This will give you all field of tableA, some field of tableB where field "ID" in tableA is equal to field "contactID" in tableB and with some condition on tableA.

I hope this help you

FoTo50

important to know would be, how to handle results (if even there) where is no match in tblA or tblB for the other one. If those can be ignored, it's a simple JOIN, that could look like:

SELECT
tblA.*,
tblB.name
FROM
tblA,
tblB
WHERE
tblA.contactid = tblB.contactid
AND
tblA.field = 'argument'
AND
tblB.field LIKE '%argument%'
ORDER BY
tblA.field

buducom

supercool. thx!! :-)