MySQL Query
Posted by: Vance Raeburn
Date: July 07, 2012 12:10AM

Any help appreciated -

I have 3 tables:

Table 1 (Postcode_Groups) where example rows are:
BS1,BS2,BS3,
BS4,BS5,BS6
etc

Table 2 (Customers) where example rows are:
customer postcode_district = 'BS2'
customer postcode_district = 'BS3'
customer postcode_district = 'BS7'


Table 3 (GolfClub) where example postcode_district of the club = 'BS3'

I need a select * on customers where golfclub postcode_district = 'BS3'

Thanks in advance - Vance (Bristol UK)



Edited 1 time(s). Last edit at 07/07/2012 09:58AM by Vance Raeburn.

Options: ReplyQuote


Subject
Written By
Posted
MySQL Query
July 07, 2012 12:10AM
July 08, 2012 09:37AM
July 09, 2012 06:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.