SV: Need help with SELECT 2 tables from choice of 3

2001-11-22 Thread Torgil Zechel
Can't you just make a check before you make a call to the DB? if( member_id 1000 ) // old member query here else // new member query here -Ursprungligt meddelande- Fran: Jerry [mailto:[EMAIL PROTECTED]] Skickat: den 21 november 2001 21:24 Till: [EMAIL PROTECTED] Amne:

SV: Need help with SELECT 2 tables from choice of 3

2001-11-22 Thread Torgil Zechel
You can join all three tables together select d.members_id, m.name, old.name from data as d left join members as m on m.members_id=d.members_id left join oldmembers as old on old.members_id=d.members_id If the members_id belongs to an old member, all fields from the member table