many thanks,Ken!

why didnt i come up with this. orz...

thanks, Ninja's_RGR'us and Amit Kumar, for your kindly reply.

i try to do my query like this:

Select

a.ShipName,a.FishingDate,a.FishingLocation,

case when b.FishSpecies = 'Jack' THEN b.CatchNumber ELSE NULL END as Jack,

case when b.FishSpecies...