Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
select a.SomeCol, count(b.SomeOtherCol)
from
(
select * from PRODUCT
) a
inner join
(
select * from ORDERS
) b
on a.PRODUCT_ID = b.PRODUCT_ID
select a, b
from myTable
UNION ALL
select a, b
from myOtherTable
# said:, WorkRelease.[Saturn Target Date], WorkRelease.[E/C Level], WorkRelease.Translation#,
WorkRelease.[Actual Due Date], WorkRelease.[Change Description], WorkRelease.[Work To Be Performed], WorkRelease.[Sample Requirements],
WorkRelease.[Initiated By], WorkRelease.Amount, JobAddChgHeader.[Start Date], JobAddChgHeader.[Due Date], JobAddChgHeader.PO#,
JobAddChgDetail.Die, JobAddChgDetail.Description, JobAddChgDetail.Amount AS Expr1, JobAddChgDetail.# said:AS Expr2
FROM JobAddChgDetail INNER JOIN
JobAddChgHeader ON JobAddChgDetail.Ref = JobAddChgHeader.[Index] RIGHT OUTER JOIN
WorkRelease ON JobAddChgHeader.[Work Rel#] = WorkRelease.[Index]
but is there something else I need in there so it writes the results to a derived table so I can requery these results? IM CONFUSED
[COLOR=blue]select[/color] x.* [COLOR=green]--'outer query'
[/color][COLOR=blue]from[/color]
([COLOR=green]--'derived table' or 'subquery' starts here
[/color][COLOR=blue]SELECT[/color] WorkRelease.[[COLOR=blue]Index[/color]], WorkRelease.[[COLOR=blue]Date[/color] Issued], WorkRelease.Job#, WorkRelease.Customer, WorkRelease.Part#, WorkRelease.[Part [COLOR=blue]Name[/color]],
WorkRelease.[Kick [COLOR=blue]Off[/color] [COLOR=blue]Date[/color]], WorkRelease.[quote=#], WorkRelease.[Saturn Target [COLOR=blue]Date[/color]], WorkRelease.[E/C [COLOR=#FF00FF]Level[/color]], WorkRelease.Translation#,
WorkRelease.[Actual Due [COLOR=blue]Date[/color]], WorkRelease.[[COLOR=blue]Change[/color] Description], WorkRelease.[[COLOR=blue]Work[/color] [COLOR=blue]To[/color] Be Performed], WorkRelease.[Sample Requirements],
WorkRelease.[Initiated [COLOR=blue]By[/color]], WorkRelease.Amount, JobAddChgHeader.[[COLOR=#FF00FF]Start[/color] [COLOR=blue]Date[/color]], JobAddChgHeader.[Due [COLOR=blue]Date[/color]], JobAddChgHeader.PO#,
JobAddChgDetail.Die, JobAddChgDetail.Description, JobAddChgDetail.Amount [COLOR=blue]AS[/color] Expr1, JobAddChgDetail.[quote=#] [COLOR=blue]AS[/color] Expr2
[COLOR=blue]FROM[/color] JobAddChgDetail [COLOR=blue]INNER[/color] [COLOR=blue]JOIN[/color]
JobAddChgHeader [COLOR=blue]ON[/color] JobAddChgDetail.Ref = JobAddChgHeader.[[COLOR=blue]Index[/color]] [COLOR=#FF00FF]RIGHT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color]
WorkRelease [COLOR=blue]ON[/color] JobAddChgHeader.[[COLOR=blue]Work[/color] Rel#] = WorkRelease.[[COLOR=blue]Index[/color]]
)[COLOR=green]--end of derived table [/color]
x[COLOR=green]--alias given to derived table[/color]
# said:, WorkRelease.[Saturn Target Date], WorkRelease.[E/C Level], WorkRelease.Translation#,
WorkRelease.[Actual Due Date], WorkRelease.[Change Description], WorkRelease.[Work To Be Performed], WorkRelease.[Sample Requirements],
WorkRelease.[Initiated By], WorkRelease.Amount, JobAddChgHeader.[Start Date], JobAddChgHeader.[Due Date], JobAddChgHeader.PO#,
JobAddChgDetail.Die, JobAddChgDetail.Description, JobAddChgDetail.Amount AS Expr1, JobAddChgDetail.# said:AS Expr2
FROM JobAddChgDetail INNER JOIN
JobAddChgHeader ON JobAddChgDetail.Ref = JobAddChgHeader.[Index] RIGHT OUTER JOIN
WorkRelease ON JobAddChgHeader.[Work Rel#] = WorkRelease.[Index]