SQL Command Problem

[vpaladan]

Kindly Help. I have two tables.

Vessel.dbf
TCode Ratings Officers
111 Doehle Gemini

Experience.dbf
Tcode Rank
111 O && Officer

How to join tables/query to output the ff.

Tcode Rank Principal (if rank = “O”, officer, else ratings
111 O Gemini

Thanks in advance

Vic

 

[craigsboyd]

Select vessel.tcode, experience.rank, iif(experience.rank = "O", vessel.officers, vessel.ratings) as principal from vessel, experience where vessel.Tcode = experience.Tcode into cursor mycursor




Slighthaze = NULL