{"id":1713061,"user_name":null,"score":2,"text":"nie wiem jaki silnik, bo s\u0105 pewne r\u00f3znice przy sk\u0142adni update z joinem.\n`ALL` mi tu za bardzo nie pasuje, bo powinien odnosi\u0107 si\u0119 do podzapytania.\njoin do `warehouse` nie jest w og\u00f3le potrzebny\n\nSkup si\u0119 na zapytaniu kt\u00f3re z tabeli `inventory` wyci\u0105gnie towary kt\u00f3rych stan jest > 70% i wykorzystaj je w join do update'a","edit_count":1,"is_voted":null,"is_accepted":null,"is_subscribed":null,"user_id":780,"deleter_name":null,"delete_reason":null,"orderingScore":2,"created_at":"2020-10-08T14:18:20+02:00","updated_at":"2020-10-08T15:36:51+02:00","deleted_at":null,"user":{"id":780,"name":"Panczo","is_online":false,"allow_sig":1,"allow_count":1,"allow_smilies":1,"posts":3900,"visited_at":"2026-05-17T18:29:50.000000Z","created_at":"2002-12-02T21:01:27.000000Z","initials":"PA","is_verified":false,"is_deleted":false,"is_incognito":false,"is_blocked":false,"is_blocked_perm":false,"deleted_at":null,"photo":null},"html":"<p>nie wiem jaki silnik, bo s\u0105 pewne r\u00f3znice przy sk\u0142adni update z joinem.<br \/>\n<code>ALL<\/code> mi tu za bardzo nie pasuje, bo powinien odnosi\u0107 si\u0119 do podzapytania.<br \/>\njoin do <code>warehouse<\/code> nie jest w og\u00f3le potrzebny<\/p>\n<p>Skup si\u0119 na zapytaniu kt\u00f3re z tabeli <code>inventory<\/code> wyci\u0105gnie towary kt\u00f3rych stan jest &gt; 70% i wykorzystaj je w join do update'a<\/p>\n","url":"http:\/\/static.175.128.202.116.clients.your-server.de\/Forum\/Bazy_danych\/344717-pomoc_w_zadaniu_sql_opartym_o_transakcje?p=1713061#id1713061","is_locked":false,"editor":{"id":780,"name":"Panczo","is_online":false,"allow_sig":1,"allow_count":1,"allow_smilies":1,"posts":3900,"visited_at":"2026-05-17T18:29:50.000000Z","created_at":"2002-12-02T21:01:27.000000Z","initials":"PA","is_verified":false,"is_deleted":false,"is_incognito":false,"is_blocked":false,"is_blocked_perm":false,"deleted_at":null,"photo":null},"permissions":{"write":false,"delete":false,"update":false,"accept":false},"moderatorPermissions":{"delete":false,"update":false,"accept":false,"merge":false,"sticky":false,"admAccess":false},"comments":[],"comments_count":0,"assets":[],"metadata":"eyJpdiI6ImZrVG9PK1BCZFBIMWZTZWQzV1BlRmc9PSIsInZhbHVlIjoid1VTVWRPcERLZGpEOWZ3cHJSbXFubEVNUnZaMW1STDhDUmhLbk1TRlMrNTcycUJBUkQ3Wk1CM0crOFNiVDNud3d6a3BQNHk3TE53Y1pZSk82MGlLVzZZNEc0bGtXSVpFUGx6cXIyZjFEL1VKaVA4VGZxQjc5WWJza3JuLys3SGwiLCJtYWMiOiI2MmFjMDhkOTMzOWJiNzhhZDAyMzA2MjU4NDAxNTFjM2M0MDA0YzA1MWM1NjA0ZWJiY2ExYWJkYjdkMGYyY2EyIiwidGFnIjoiIn0=","has_review":false,"review_style":"info","parentPostId":null,"childrenFolded":false,"type":"regular","highlighted":false}