PHP Classes

File: samples/select.sql

Recommend this page to a friend!
  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: 15 years ago
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