SQL - have a result from one select into another select -
I have two subqueries that I want to select two different columns, but I do not know how now Trying for a long time.
In other words, I need to do this:
Choose from a different A, B (selectstatement 1 to * select *, selectstatement 2);
What do I have
I get two tables, table 1 and table 2, three columns of three types.
I have:
selectstatement 1: from Table 2, select Table 2; Selectstatement 2: Specific Table 1. A, Table 1. B, Table 2. A, Table 2. Select the table B-1, Table 2 (Table 1. A & gt; Table 1. B and Table 2. A & gt; Table 2. b) or (Table 1. B & gt; Table 1A and Table 2 .b & gt; Table 2a.);
Whatever problem I have now, I have selected columns A and B from this select statement such as choose from A, B (selectstatement 1 to select *, selectstatement 2);
But whatever I have tried, it is not working.
It does not work:
specific PA, PB, TA, (separate table TB 1. A, Table 1. B, Table 2. A table 2. B, table 1, select the table 2 (table 1 AA; table 1 B and table 2 AA tab 2. b) or (table 1 B & gt; table 1A and table 2. B & gt; table 2. A)) as P, (Table 1, select * from Table 2) as T;
But it is also wrong that I should " Choose from different A, B (* select from selectstatement 1, selectstatement 2);
", not
Try this code.
choose t1.ks, t1 [# Work], (# 2) as [# late] (Select KS, COUNT (*) as incorporated by # Table Group 'KS) left T1 (Select KS, T1.ks Table 2 on T2 on = t2.ks
Comments
Post a Comment