Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi all, The following SQL syntax

Status
Not open for further replies.
Palmero

Palmero

Technical User
Mar 31, 2001
53
0
0
FR
Hi all,

The following SQL syntax does work on Oracle, but not on Sybase.
Do you have a workaround without using a temporary table?
Thanks in advance for your help.

SELECT T1.code,T2.label FROM
(SELECT ......) T1,
(SELECT ......) T2
WHERE T1.code=T2.code;

Palmero.

 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
74
AM_WG
AM_WG
JeanTheresa
  • Locked
  • Question
PowerBuilder 6 and Sybase SQL Anywhere Studio 6.0.3
Replies
0
Views
54
JeanTheresa
JeanTheresa
ouch8s
  • Locked
  • Question
Hi, Forgive my terminology if I
Replies
2
Views
57
yelworcm
yelworcm
Mifo
  • Locked
  • Question
Sybase 12.5 and Dynamic SQL
Replies
1
Views
53
cherie0202
cherie0202
skibear99
  • Locked
  • Question
Select "All Records"
Replies
1
Views
43
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top