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

04.14.2008 at 08:23AM PDT, ID: 23320608 | Points: 250

	[x] Attachment Details

How do you write a query to return the results for the table with all the people whose name starts with J in the following single row format:

Asked by sinuhepena in Data Manipulation, MySQL, SQLBase

Tags: microsoft, sql, 2000

If you have a table

Name
With the fields:
FirstName
LastName
ID

How do you write a query to return the results for the table with all the people whose name starts with J in the following single row format:

FirstName, LastName, ID, FirstName, LastName, ID, FirstName, LastName, IDStart Free Trial

Keywords: How do you write a query to return the…

	Title
1	How to set reference to .JAR or .CL…
2	the "J" prefix
3	whose java
4	Turning LASTNAME, Firstname into L…
5	Unlimited Combinations
6	MS J++ with WinXP

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628