Code Forums - View Single Post

sde · 08-17-2004, 05:07 AM

i don't understand what field your table/field your personell is in.

could you describe your database a little better? if it is field 1 and field2, then maybe:

Code:

select distinct Field2 from Vessel where Field1='VictorVsl';

that will work if field 2 is the names of peronnel, .. but i'm not sure i understand your db structure.

08-17-2004, 05:07 AM	#2 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,505	i don't understand what field your table/field your personell is in. could you describe your database a little better? if it is field 1 and field2, then maybe: Code: select distinct Field2 from Vessel where Field1='VictorVsl'; that will work if field 2 is the names of peronnel, .. but i'm not sure i understand your db structure. __________________ Mike