Template:TNG showdata/get crew test: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#get_db_data: | <!--{{#get_db_data:--> | ||
db=tng_db | db=tng_db | ||
|from= tng_people RIGHT JOIN wk1_datatable2_data ON | |from= tng_people <!--RIGHT--> JOIN wk1_datatable2_data ON wk1_datatable2_data.dtd_04 = (SELECT TOP 1 dtd_04 FROM wk1_datatable2_data WHERE dtd_04 = tng_people.personID) | ||
|where wk1_datatable2_data.dtd_04 in (SELECT DISTINCT wk1_datatable2_data.dtd_04 FROM wk1_datatable2_data) | <!-- |where wk1_datatable2_data.dtd_04 in (SELECT DISTINCT wk1_datatable2_data.dtd_04 FROM wk1_datatable2_data) --> | ||
<!-- |limit=50 --> | <!-- |limit=50 --> | ||
|order by=tng_people.personID ASC <!--ID--> | |order by=tng_people.personID ASC <!--ID--> | ||
| Line 10: | Line 10: | ||
{{documentation}} | {{documentation}} | ||
</noinclude> | </noinclude> | ||
<!-- | |||
SELECT Orders.OrderNumber, LineItems.Quantity, LineItems.Description | |||
FROM Orders | |||
JOIN LineItems | |||
ON LineItems.LineItemGUID = | |||
( | |||
SELECT TOP 1 LineItemGUID | |||
FROM LineItems | |||
WHERE OrderID = Orders.OrderID | |||
) | |||
tng_people.personID | |||
--> | |||
Revision as of 14:06, 22 September 2014
db=tng_db |from= tng_people JOIN wk1_datatable2_data ON wk1_datatable2_data.dtd_04 = (SELECT TOP 1 dtd_04 FROM wk1_datatable2_data WHERE dtd_04 = tng_people.personID) |order by=tng_people.personID ASC |data=personID=tng_people.personID,tnglastname=tng_people.lastname,tngfirstname=tng_people.firstname,crewlastname=wk1_datatable2_data.dtd_07,crewfirstname=wk1_datatable2_data.dtd_08}} {{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}