samples/select.sql - SQL Parse and Compile

File:

samples/select.sql

Role:

Auxiliary data

Content type:

text/plain

Description:

sample select

Class:

SQL Parse and Compile
Parse and compose SQL queries programatically

Contents

Download

SELECT
state.title AS statetitle,
city.title AS citytitle ,
agencies.Fullaganyname AS agenciesFullaganyname ,
recordLog.bookptitle AS recordLogbookptitle ,
recordLog.pubperntitle AS recordLogpubperntitle ,
bookDetails.name AS bookDetailsname ,
bookDetails.id AS bookDetailsid

FROM WordsState AS state,
WordsCity AS city
, WordsShopAgencyCenter AS agencies
, IOLog_AgancyCenter AS recordLog
, WordsBookDetail AS bookDetails
WHERE state.id=recordLog.agancystateid 
AND city.id=recordLog.agancycityid 
AND agencies.id=recordLog.ShopAgencyCenterid 
AND bookDetails.id=recordLog.bid 
LIMIT 0,20

For more information send a message to :
info at phpclasses dot org.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

	Classes of Tom Schaefer	>	SQL Parse and Compile	>	samples/select.sql

File: samples/select.sql

Contents