That, and typing "select x from table A, table B where tableA.foreign_key = tabl... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		manicdee on May 27, 2014 \| parent \| context \| favorite \| on: You shouldn’t use a spreadsheet for important work That, and typing "select x from table A, table B where tableA.foreign_key = tableB.index and tableA.index=5" is a little long-winded and more prone to error, when you can just do x = ModelA.objects.get(pk=5).ModelB

chris_mahan on June 6, 2014 [–]

SELECT B.x FROM tableA A JOIN tableB B on A.foreign_key = B.index WHERE A.index = 5

That's very simple, if you know SQL.

I think

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact