sql query

[Anon]

I need a sql query tahta allows me to "select" data from tables like follows

Table Client
client_id
client_name
client_type_id

Table Type
type_id
type_discription

The select would "select" data from table client, and client_type_id would be getting (type table's) type_discription.

I want to put in a page:

Client Name || Client tYpe

client name is the name of the client_id inserted, and client type is the discription of the client_type_id..

[Anon]

Very vaguely post, I must say :-)

However, you must link your data.
Column client_id sholud be present in Type table, so you'll have the client_id value for every record in Type table.

Hope this helps.

Slaven

[Anon]

SELECT c.client_id,c.client_name,t.type_description FROM client c, type t WHERE c.client_type_id=t.type_id

I think that'll work....assuming I understood you correctly. 🙂

---John Holmes...