Re: Can I do this with SQL

you may simulate two tables making two views of your codes tables. i mean

view 1:

create view codesof1stthing as
select * from codes where code in (val1,val2,val3)

view 2:

create view codesof2ndthing as
select * from codes where code in (val4,val5,val6....)

and then make the join with your personel table

select fields you want
from personel,codesof1stthing ,codesof2ndthing where personel.code=codesof1stthing.code and personel.code=codesof2ndthing.code

or something like this Received on Tue Mar 02 1999 - 02:53:17 CST