The thing is to estimate costs of making any garment with any
materials. I need to join all garments to all materials, !
You're trying to produce what's called a Cartesian product.
This can be done in SQL simply by omitting any join condition. The
default join (with no condition limiting it) joins every row in one
table to every row in the other table:
SELECT GARMENT.*, MATERIAL.MATERIAL_NO
FROM GARMENT, MATERIAL;
This should work in Oracle, MySQL, or any other system that supports the
most rudimentary features of SQL.
Re: embedded SQL in COBOL ... I still have 'Learner' plates up for SQL - fortunately with N/E, having defined your DB, it allows you to select Query Type and it generates from EXEC to END-EXEC including the troublesome NULLs. ...DBI Main. ... Not shown in the above flowchart is a template for Dialogs to which I pass creation parametersand subsequently send data or receive data back - using the class Edit Materials as the Controller, ). ... MakeCollection - CURSOR SELECT DISTINCT ... (comp.lang.cobol)
Re: c++ and database ... > languages using ODBC and SQL.... > materials which make me work with this databases (I use Borland free... (comp.lang.cpp)
Re: problem with multiple join table query on report ... PAYMENT, SumAS DLABOR, SumAS ...MATERIALS... if only the SOREPORT AND TRANSACTION table is joined i do get the data that i ... We'd be glad to help if we could but since you have not posted the SQL of the ... (microsoft.public.access.modulesdaovba)
Re: Combo box data vanishing ... position combo AND a materials combo. ... All combos were set up interactively using SQL in the row source.... This can be a hassle to solve; one way is to create a textbox... (microsoft.public.access.forms)
Re: SQL Select: Very Fast in VFP8, Very Slow in VFP9 ... JOIN for the two tables contained the following JOIN condition:... When I removed the ALLTRIM functions, the SQL Select statement in VFP9... (microsoft.public.fox.programmer.exchange)
