Code Forums - View Single Post

infinite_root · 08-16-2004, 11:55 PM

Hi I had a problem, hope you can help me.

Here's my database info:

Database name: sms
Table1: Visa
Field: Visa (there are many types of visa entry such as V001, V002, etc.)

Table2: Vessel
Field1: VictorVsl
Field2: Onboard

Here's what I would like to do:

I would like my query to provide search results of "all personnel" with or without "visa", which were "onboard" on a vessel named "VictorVsl" to be listed on the list.

HOw can I do that?

I am using MySQL 4.0.20-1.

Thanks and more power.

08-16-2004, 11:55 PM	#1 (permalink)
infinite_root Registered User Join Date: Apr 2004 Posts: 26	Help on MySQL Statements Hi I had a problem, hope you can help me. Here's my database info: Database name: sms Table1: Visa Field: Visa (there are many types of visa entry such as V001, V002, etc.) Table2: Vessel Field1: VictorVsl Field2: Onboard Here's what I would like to do: I would like my query to provide search results of "all personnel" with or without "visa", which were "onboard" on a vessel named "VictorVsl" to be listed on the list. HOw can I do that? I am using MySQL 4.0.20-1. Thanks and more power.