|
|
Posted by Shelly on 09/28/38 11:22
"Geoff Berrow" <blthecat@ckdog.co.uk> wrote in message
> I'm not an SQL expert but you could probably do
>
> SELECT DISTINCT col1,col2,col3... FROM tbl1,tbl2,tbl3 WHERE
> tbl1.id=tbl2.id AND tbl2.id=tbl3.id AND (bio109 ='A' OR history101='B')
You beat me to it. This is basic SQL, and has nothing to do with PHP. I
just had to do one for myself where I did:
select a.*, b.field1 from a, b where a.id=b.id;
Shelly
Navigation:
[Reply to this message]
|