Home » RDBMS Server » Server Administration » Re: complex query - Help required
Re: complex query - Help required [message #374547] Mon, 18 June 2001 10:45
Arvind L
Messages: 27
Registered: June 2001
Junior Member
Let me know if this works for u,
select x.quote_id, x.section_id, x.roof_system_id, r.long_name from quote_section_xref x, roof_system r
where x.roof_system_id=r.roof_system_id AND
r.roof_system_type='&t';

bye
Arvind

Report message to a moderator

Previous Topic: Complex Query!!!!!!!!!!!!!!!!!!!!!!!!!
Next Topic: Printing/inserting/selecting of some special chars
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 06:41:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.