•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,574 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,684 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 1241 | Replies: 5
•
•
Join Date: Jun 2005
Location: USA
Posts: 147
Reputation: 
Rep Power: 4
Solved Threads: 1
Junior Poster
Problem:
I have two tables and those two table have one field in common which is "S_ID"
first table have 2 fields:
"S_ID", "T_ID"
second table have these fields:
"S_ID", "First", "Last"
----------------------------------
What i want to do is that i need to extract the the field "S_ID" from the first table and order them by the field "Last" which is in the other table.
any one know how i can do that in one or 2 query.
Also I am using php.
I have two tables and those two table have one field in common which is "S_ID"
first table have 2 fields:
"S_ID", "T_ID"
second table have these fields:
"S_ID", "First", "Last"
----------------------------------
What i want to do is that i need to extract the the field "S_ID" from the first table and order them by the field "Last" which is in the other table.
any one know how i can do that in one or 2 query.
Also I am using php.
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded ModeSimilar Threads
- Removing Query Strings (ASP.NET)
- Double MySQL Query (PHP)
- Dynamic Query (JSP)
- MySQL nested query / joined query conversion help (MySQL)
- problem with lengthy query (Java)
- Retreiving variables from a sql query into a form (PHP)
- Sql Query (VB.NET)
- Query Building (Database Design)
Other Threads in the MySQL Forum
- Previous Thread: cannot connect mysql 5.0 live server though command prompt
- Next Thread: most popular scripting language
