All pastes #329866 Raw Edit

Anonymous

public text v1 · immutable
#329866 ·published 2007-01-27 02:43 UTC
rendered paste body
my way:

SELECT t1.primaryKey, t1.name, t1.timeStamp, t1.userName, t1.trace, t1.version, t1.blessingLevel, t1.commentID, t1.propertiesID, t1.binFile, t1.parcelID, t2.primaryKey, t2.blobType, t2.blobData, t2.blobData
 FROM (TW_Package t1 INNER JOIN TW_Blob t2 ON (t1.commentID = t2.primaryKey))

isomers way:
SELECT t1.primaryKey, t1.name, t1.timeStamp, t1.userName, t1.trace, t1.version, t1.blessingLevel, t1.commentID, t1.propertiesID, t1.binFile, t1.parcelID, t2.primaryKey, t2.blobType, t2.blobData, t2.blobData
 FROM (TW_Package t1 INNER JOIN TW_Blob t2 ON (t1.commentID = t2.primaryKey))