sheetal
|
| Posted: 12/10/2005, 2:09 AM |
|
Hi there
I need to select columns from multiple tables by performing a join.
How to do it
|
|
|
 |
Walter Kempees
|
| Posted: 12/10/2005, 4:55 AM |
|
Sheetal,
You have to be more specific:
- Do you already know how to do joins in SQL?
- do you already know the different type of joins in SQL?
- do you know how to do SQL in CCS, hoe to use VQB
- Whate and where do you need help with exactly.
Please also state version of CCS and Language/SQL version, even post your
qquestion in the language specific forum.
Snapshot of table definition might be helpful too.
After that I know everybody will be willing to help.
Have a great weekend,
Walter
"sheetal" <sheetal@forum.codecharge> schreef in bericht
news:17439aa96496436@news.codecharge.com...
> Hi there
> I need to select columns from multiple tables by performing a join.
>
> How to do it
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
pragadees
|
| Posted: 12/24/2005, 2:24 AM |
|
what are the types of select statement
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/24/2005, 11:43 AM |
|
Different databases may support different SQL syntax and select statements. Take a look at http://www.google.com/search?hl=en&q=sql+select+statement
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Sumit Kumar
|
| Posted: 02/17/2006, 3:07 AM |
|
 Use UNION statement
SELECT * from t1 UNION * from t2 ......
|
|
|
|
|
