ben
|
| Posted: 04/23/2002, 9:13 PM |
|
anyone knows how to show two fields in one listbox?that means if i have two fields from the same table one is subjectid and one is subjectname.?
|
|
|
 |
Carlos
|
| Posted: 04/23/2002, 10:34 PM |
|
It depends on the database that you are using. If you are using mySQL for instance you can use concat to concatenate the two fields.
e.g. select concat(subjectid, " - ", subjectname) from subject
|
|
|
|
ben
|
| Posted: 04/24/2002, 1:39 AM |
|
if i am using access 2000.then what will be the sql statement?
|
|
|
|
|
