|
Lines 2245-2251
sub GetItemIssue {
Link Here
|
| 2245 |
my ($itemnumber) = @_; |
2245 |
my ($itemnumber) = @_; |
| 2246 |
return unless $itemnumber; |
2246 |
return unless $itemnumber; |
| 2247 |
my $sth = C4::Context->dbh->prepare( |
2247 |
my $sth = C4::Context->dbh->prepare( |
| 2248 |
"SELECT * |
2248 |
"SELECT items.*, issues.* |
| 2249 |
FROM issues |
2249 |
FROM issues |
| 2250 |
LEFT JOIN items ON issues.itemnumber=items.itemnumber |
2250 |
LEFT JOIN items ON issues.itemnumber=items.itemnumber |
| 2251 |
WHERE issues.itemnumber=?"); |
2251 |
WHERE issues.itemnumber=?"); |
| 2252 |
- |
|
|