Re: Query Help

2002-02-20 Thread Web boy
Is there another way as I do not have that version of MYSQL installed on my server? THanks- KCK --- Tod Harter <[EMAIL PROTECTED]> wrote: > On Wednesday 20 February 2002 09:20, Web boy wrote: > > You want to use UNION. If I remember correctly its a > fairly new feature for

Query Help

2002-02-20 Thread Web boy
Hello I have a query that goes through and gets the data out of three tables without a problems. Now the task at hand is to compair that out put against three identiacal tables not displaying any duplicate date. Tables: a a.aocode , a.CaseNo , a.CaseName b. b.ao_code , b.initials c c.CaseNo