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 strongm 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
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
167
AM_WG
AM_WG
JeanTheresa
  • Locked
  • Question
PowerBuilder 6 and Sybase SQL Anywhere Studio 6.0.3
Replies
0
Views
111
JeanTheresa
JeanTheresa
ouch8s
  • Locked
  • Question
Hi, Forgive my terminology if I
Replies
2
Views
118
yelworcm
yelworcm
Mifo
  • Locked
  • Question
Sybase 12.5 and Dynamic SQL
Replies
1
Views
99
cherie0202
cherie0202
skibear99
  • Locked
  • Question
Select "All Records"
Replies
1
Views
92
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top