August 30, 2008 12:12am pdt

1. angelIII 13,900
2. chapmandew 8,200
3. cactus_d... 4,000
3. EugeneZ 4,000
3. jinesh_ka... 4,000
6. mark_wills 3,580
7. ee_rlee 3,400
8. dragos_c... 3,000
9. dportas 2,950
10. mlmcc 2,200
11. gbshahaq 2,164
12. knightEkni... 2,000
12. dvz 2,000
12. dtodd 2,000
12. aneeshatti... 2,000
12. dorianm 2,000
12. saurabh726 2,000
12. Zippit 2,000
12. burrcm 2,000
12. sujith80 2,000
12. BillBach 2,000
12. Thomasian 2,000
12. matthewr... 2,000
12. coldboy 2,000
12. Smart_Man 2,000

1. angelIII 20,200
2. chapmandew 8,200
3. dqmq 5,630
4. gbshahaq 4,164
5. cactus_d... 4,000
5. jinesh_ka... 4,000
5. EugeneZ 4,000
8. mark_wills 3,580
9. ee_rlee 3,400
10. nedfine 3,375
11. dragos_c... 3,000
11. ram_0218 3,000
13. dportas 2,950
14. harfang 2,664
15. sujith80 2,600
16. jerryb30 2,500
17. rockiroads 2,400
18. gatorvip 2,375
18. rorya 2,375
20. mlmcc 2,200
21. capricorn1 2,100
22. knightEkni... 2,000
22. dvz 2,000
22. TechSoEasy 2,000
22. yodercm 2,000
22. vadimrapp1 2,000
22. aneeshatti... 2,000
22. RQuadling 2,000
22. johnsone 2,000
22. dtodd 2,000
22. mr_egypt... 2,000
22. Kdo 2,000
22. rbrooker 2,000
22. stevbe 2,000
22. Smart_Man 2,000
22. coldboy 2,000
22. saurabh726 2,000
22. cpkilekofp 2,000
22. momi_sa... 2,000
22. epochasset 2,000
22. _agx_ 2,000
22. Jillyn_D 2,000
22. Raynard7 2,000
22. BillBach 2,000
22. ryancys 2,000
22. matthewr... 2,000
22. dorianm 2,000
22. Thomasian 2,000
22. burrcm 2,000
22. andrewbl... 2,000
22. Zippit 2,000
22. jimpen 2,000

02.27.2008 at 10:27AM PST, ID: 23197903

	[x] Attachment Details

SQL: Query a value in Table1, use the result to query a result set in Table2

Asked by rfwoolf in Data Manipulation, MySQL, Data Mining

I need to know how to do this in SQL.

Below you will find the two tables and some examples of the results I want.

Basically I will have a user input like "Vehicles", and I will need it to
1) Find "Vehicles" in the field "CATEGORY DESCRIPTION" [RECORD3]
2) Get its "CATEGORY CODE" [VEH]
3) SELECT all records in TABLE2 with the "CATEGORY CODE" = "VEH"Start Free Trial

         
           
           
             ===TABLE 1===
 FIELDS: CATEGORY DESCRIPTION  | CATEGORY CODE
RECORD1: Furniture               FRNTR
RECORD2: Foodstuffs              FOOD
RECORD3: Vehicles                VEH
 
===TABLE 2===
 FIELDS: SUBCATEGORY DESCRIPTION  | CATEGORY CODE
RECORD1: Tables                     FRNTR
RECORD2: Chairs                     FRNTR
RECORD3: Sedans                     VEH
RECORD4: Trucks                     VEH
RECORD5: Bikes                      VEH
 
Example 1: If the user inputs "Vehicles", I want Records 3-5 of TABLE 2.
Example 2: If the user inputs "Furniture", I want Records 1-2 of TABLE 2.

           
         

Keywords: SQL: Query a value in Table1, use …

	Title
1	In Table1 but not in Table2
2	select * from table1, table2, table3
3	Update table1 from table2
4	How do I get the 284 to show that ar…
5	Select top 1 from table2 for each rec…
6	Verifying TABLE2 records based on T…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_EXPERT_20070906

SQL: Query a value in Table1, use *the* result to query a result set in Table2

Asked by rfwoolf in Data Manipulation, MySQL, Data Mining

About this solution

SQL: Query a value in Table1, use the result to query a result set in Table2