Hi,
I have 4 tables and need to use 1 query for displaying :
prodbarcode,prod_description,stock_on_hand,qty, (qty-stock_on_hand) Variance,
cost_price, (Variance*cost_price) Var_Amount for a specific store in StCount.
StCount contains several sessionid for 1 store.
C_Sess contains all the prodb
R JOIN attractions AS at USING (attractionid);
PB
-
Neil Tompkins wrote:
Hi,
How do I query multiple tables. For example I have
TableName Accommodation
Field1 AccommodationID
Field2 AccommodationName
I also have
TableName Attractions
Field1Attrac
Hi,
How do I query multiple tables. For example I have
TableName Accommodation
Field1 AccommodationID
Field2 AccommodationName
I also have
TableName Attractions
Field1AttractionID
Field2 AttractionName
Field3
Hi
Hi I want to query multiple tables and think I need a little help
Using this example I have 2 tables
Table1
Table Name: one
Field: Surname
Field: Setnumber
Table2
Table Name: two
Field: Surname
Field: Setnumber
Using:
SELECT COUNT(*) AS res, FROM one, two where one.surname like
TASK:
I have to generate a report with all categories, subcategories and
products in database.
PROBLEM:
I want to write one query that will return:
1. category
2. subcategory: determined by parent_id
3. products in each category or subcategory.
I have four tables with the following structure:
-
