Login   Register  
PHP Classes
elePHPant
Icontem

File: samples/select.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tom Schaefer  >  SQL Parse and Compile  >  samples/select.sql  >  Download  
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
Author: By
Last change: complex select
Date: 2009-02-06 00:46
Size: 608 bytes
 

Contents

Class file image 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